package com.example.mapper.one;

import com.example.pojo.ThesisInfo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ThesisMapper {
    List<ThesisInfo> getThesisData(@Param("gradeId")Integer gradeId, @Param("majorId")Integer majorId, @Param("teamId")Integer teamId, @Param("sno")Integer sno, @Param("sname")String sname);
    int addThesisInfo(ThesisInfo thesisInfo);
    int setEnclosureFile(@Param("enclosureFileName")String enclosureFileName, @Param("sNo")Integer sNo);
    int queryExit(@Param("sNo")Integer sNo);
    int updateThesisInfo(ThesisInfo thesisInfo);
    int updateThesisPart(@Param("sNo")Integer sNo,@Param("thesisTitle")String thesisTitle,@Param("keywords")String keywords);
    int deleteThe(@Param("sNo")Integer sNo);
    String getThesisFileName(@Param("sNo")Integer sNo);
    String getEnclosureFileName(@Param("sNo")Integer sNo);
    List<String> queryKeywords(@Param("majorId")Integer majorId);
}
